2015-07-01 - 16728 - Spec -Supply Chain integration for Sourcing #SNCDOTNET #SNCProject
SPECIFICATIONS
16728.1100-Spec-Supply Chain integration for sourcing
Purpose
Create a .Net application for SNC to update and download work order confirmations
Admin Info
Purpose
|
Create a .Net application for SNC to update and download work order confirmations
|
Requested By
|
Jingsha
|
Spec Created By
|
Vamshi
|
Spec Created Date
|
07/09/2015
|
Spec QA by
|
Vamshi
|
Document Status
|
Complete
|
Estimates
Sl.No
|
Activity
|
Estimation in Hours
|
1
|
Research
|
|
2
|
Documentation
|
|
3
|
Development/ Config
|
|
4
|
Unit test in DEV
|
|
5
|
Unit test in QUA
|
|
6
|
Other activity
|
|
|
TOTAL
|
|
References
Prior Tickets
[Provide links of prior associated Spec / Break Fix BOSS document(s)]
Documents
[Attach any document(s) received for the requirement(s)]
Spec Changes
[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]
Sl.
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
[Explain the purpose of the project and the reason why this requirement has come]
Create a .Net application for SNC to update and download work order confirmations
In Scope:
[List the
activities to be included in scope]
Out of Scope:
[Out of scope activities]
Solution Summary
[Discuss this section with Requester and get approval prior to beginning work]
Create a .Net application for SNC to update and download work order confirmations.
Create a SSIS package to import the data from the extracts from SNC. The package will be scheduled to run daily once.
Test Plan
[List test scenarios/cases to be executed here]
Test ID
|
Test Scenario
|
Expected Results
|
001
|
Enter PO number and click on Apply
|
The work order details for the PO will be displayed in the grid
|
002
|
Update the confirmations for the Phases by check
and unchecking the checkboxes and save
|
User should be able to check and uncheck the checkboxes for the phase completed
and the data should be saved to database on Save click
|
003
|
Day End Process
|
User should be able to download the updated confirmations.
|
Solution Details
[Provide complete technical details for configuration or programming here]
SSIS Package:
- FTP the files from the SNC location and place in the package location.
- Package will import the data from the files and archive the processed files.
Application:
- Application to display the workorder details in the grid and the ability to update the phase completed details in the grid.
- Application takes vendor as parameter and displays only the details for that vendor.
- Search based on the PO.
- Ability to Save confirmations
- Ability to download the confirmations to a CSV file
Issues
[List Issues / Bugs identified in configuration or development]